Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 65281 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 3657 |
| Duplicate rows (%) | 5.6% |
| Total size in memory | 6.0 MiB |
| Average record size in memory | 96.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Text | 1 |
| Categorical | 2 |
| Dataset has 3657 (5.6%) duplicate rows | Duplicates |
Discount Amount is highly overall correlated with Sales Amount and 3 other fields | High correlation |
List Price is highly overall correlated with Sales Price and 1 other fields | High correlation |
Sales Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Amount Based on List Price is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Cost Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Margin Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Price is highly overall correlated with List Price and 1 other fields | High correlation |
Sales Quantity is highly overall correlated with List Price and 1 other fields | High correlation |
Sales Cost Amount is highly skewed (γ1 = 21.01078573) | Skewed |
Sales Quantity is highly skewed (γ1 = 23.00739577) | Skewed |
Discount Amount has 1214 (1.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-11 10:28:36.555141 |
|---|---|
| Analysis finished | 2023-07-11 10:28:51.157432 |
| Duration | 14.6 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
CustKey
Real number (ℝ)
| Distinct | 615 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10017703 |
| Minimum | 10000453 |
|---|---|
| Maximum | 10027583 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | 10000453 |
|---|---|
| 5-th percentile | 10002506 |
| Q1 | 10012715 |
| median | 10019665 |
| Q3 | 10023511 |
| 95-th percentile | 10026006 |
| Maximum | 10027583 |
| Range | 27130 |
| Interquartile range (IQR) | 10796 |
Descriptive statistics
| Standard deviation | 7176.1904 |
|---|---|
| Coefficient of variation (CV) | 0.0007163509 |
| Kurtosis | -0.37137474 |
| Mean | 10017703 |
| Median Absolute Deviation (MAD) | 4886 |
| Skewness | -0.77019433 |
| Sum | 6.5396565 × 1011 |
| Variance | 51497708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10025919 | 2760 | 4.2% |
| 10019194 | 2752 | 4.2% |
| 10012715 | 1431 | 2.2% |
| 10012226 | 1389 | 2.1% |
| 10025025 | 1143 | 1.8% |
| 10023524 | 1042 | 1.6% |
| 10020515 | 1010 | 1.5% |
| 10017638 | 792 | 1.2% |
| 10022456 | 741 | 1.1% |
| 10002506 | 714 | 1.1% |
| Other values (605) | 51507 |
| Value | Count | Frequency (%) |
| 10000453 | 329 | |
| 10000455 | 19 | < 0.1% |
| 10000456 | 104 | 0.2% |
| 10000457 | 19 | < 0.1% |
| 10000458 | 10 | < 0.1% |
| 10000460 | 120 | 0.2% |
| 10000461 | 251 | |
| 10000462 | 3 | < 0.1% |
| 10000466 | 123 | 0.2% |
| 10000469 | 162 |
| Value | Count | Frequency (%) |
| 10027583 | 25 | < 0.1% |
| 10027575 | 5 | < 0.1% |
| 10027572 | 52 | 0.1% |
| 10027560 | 42 | 0.1% |
| 10027381 | 108 | |
| 10027370 | 235 | |
| 10027356 | 21 | < 0.1% |
| 10027348 | 14 | < 0.1% |
| 10027340 | 35 | 0.1% |
| 10027119 | 176 |
Discount Amount
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 17821 |
|---|---|
| Distinct (%) | 27.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1855.5748 |
| Minimum | -255820.8 |
|---|---|
| Maximum | 343532.66 |
| Zeros | 1214 |
| Zeros (%) | 1.9% |
| Negative | 972 |
| Negative (%) | 1.5% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | -255820.8 |
|---|---|
| 5-th percentile | 18.68 |
| Q1 | 246.04 |
| median | 441.76 |
| Q3 | 999.76 |
| 95-th percentile | 6353 |
| Maximum | 343532.66 |
| Range | 599353.46 |
| Interquartile range (IQR) | 753.72 |
Descriptive statistics
| Standard deviation | 9037.0717 |
|---|---|
| Coefficient of variation (CV) | 4.8702275 |
| Kurtosis | 379.74222 |
| Mean | 1855.5748 |
| Median Absolute Deviation (MAD) | 233.95 |
| Skewness | 10.841862 |
| Sum | 1.2113378 × 108 |
| Variance | 81668664 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1214 | 1.9% |
| 24.88 | 103 | 0.2% |
| 606.84 | 100 | 0.2% |
| 639.82 | 97 | 0.1% |
| 634.6133 | 93 | 0.1% |
| 402.7 | 93 | 0.1% |
| 601.9033 | 93 | 0.1% |
| 918.1412 | 88 | 0.1% |
| 385.98 | 87 | 0.1% |
| 169.36 | 87 | 0.1% |
| Other values (17811) | 63226 |
| Value | Count | Frequency (%) |
| -255820.8 | 1 | < 0.1% |
| -245587.97 | 1 | < 0.1% |
| -238792.73 | 1 | < 0.1% |
| -231837.6 | 3 | |
| -222564.1 | 3 | |
| -127176 | 1 | < 0.1% |
| -122088.96 | 1 | < 0.1% |
| -84573.72 | 1 | < 0.1% |
| -81190.77 | 1 | < 0.1% |
| -53626 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 343532.66 | 2 | |
| 339103.35 | 1 | < 0.1% |
| 331487.76 | 2 | |
| 327213.75 | 1 | < 0.1% |
| 322454.09 | 1 | < 0.1% |
| 210371 | 4 | |
| 202995 | 4 | |
| 191196.5532 | 2 | |
| 189333.9 | 1 | < 0.1% |
| 182832.8832 | 2 |
Item
Text
| Distinct | 657 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 510.1 KiB |
Length
| Max length | 37 |
|---|---|
| Median length | 32 |
| Mean length | 21.722278 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1418052 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Nationeel Salted Pretzels |
|---|---|
| 2nd row | Ebony Prepared Salad |
| 3rd row | Thresher Spicy Mints |
| 4th row | Big Time Frozen Cheese Pizza |
| 5th row | Red Spade Turkey Hot Dogs |
| Value | Count | Frequency (%) |
| canned | 6378 | 2.8% |
| ebony | 5460 | 2.4% |
| cheese | 5194 | 2.3% |
| better | 4570 | 2.0% |
| red | 4271 | 1.9% |
| top | 4173 | 1.8% |
| spade | 4161 | 1.8% |
| high | 4138 | 1.8% |
| best | 3480 | 1.5% |
| nationeel | 3328 | 1.4% |
| Other values (294) | 184534 |
Most occurring characters
| Value | Count | Frequency (%) |
| 164406 | 11.6% | |
| e | 147096 | 10.4% |
| o | 92467 | 6.5% |
| a | 92276 | 6.5% |
| n | 74074 | 5.2% |
| i | 69460 | 4.9% |
| t | 68733 | 4.8% |
| r | 67352 | 4.7% |
| l | 59835 | 4.2% |
| s | 57796 | 4.1% |
| Other values (46) | 524557 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1013747 | |
| Uppercase Letter | 236243 | 16.7% |
| Space Separator | 164406 | 11.6% |
| Dash Punctuation | 2160 | 0.2% |
| Other Punctuation | 748 | 0.1% |
| Decimal Number | 748 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 147096 | |
| o | 92467 | 9.1% |
| a | 92276 | 9.1% |
| n | 74074 | 7.3% |
| i | 69460 | 6.9% |
| t | 68733 | 6.8% |
| r | 67352 | 6.6% |
| l | 59835 | 5.9% |
| s | 57796 | 5.7% |
| d | 40545 | 4.0% |
| Other values (16) | 244113 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 31428 | |
| C | 30873 | |
| S | 26130 | |
| T | 19374 | 8.2% |
| F | 16239 | 6.9% |
| M | 12522 | 5.3% |
| P | 11469 | 4.9% |
| L | 11022 | 4.7% |
| D | 10754 | 4.6% |
| E | 10237 | 4.3% |
| Other values (15) | 56195 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 579 | |
| 2 | 169 | 22.6% |
Space Separator
| Value | Count | Frequency (%) |
| 164406 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2160 |
Other Punctuation
| Value | Count | Frequency (%) |
| % | 748 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1249990 | |
| Common | 168062 | 11.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 147096 | 11.8% |
| o | 92467 | 7.4% |
| a | 92276 | 7.4% |
| n | 74074 | 5.9% |
| i | 69460 | 5.6% |
| t | 68733 | 5.5% |
| r | 67352 | 5.4% |
| l | 59835 | 4.8% |
| s | 57796 | 4.6% |
| d | 40545 | 3.2% |
| Other values (41) | 480356 |
Common
| Value | Count | Frequency (%) |
| 164406 | ||
| - | 2160 | 1.3% |
| % | 748 | 0.4% |
| 1 | 579 | 0.3% |
| 2 | 169 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1418052 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 164406 | 11.6% | |
| e | 147096 | 10.4% |
| o | 92467 | 6.5% |
| a | 92276 | 6.5% |
| n | 74074 | 5.2% |
| i | 69460 | 4.9% |
| t | 68733 | 4.8% |
| r | 67352 | 4.7% |
| l | 59835 | 4.2% |
| s | 57796 | 4.1% |
| Other values (46) | 524557 |
List Price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 1062 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 514.70126 |
| Minimum | 0 |
|---|---|
| Maximum | 2760.7 |
| Zeros | 295 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 36.69 |
| Q1 | 181.56 |
| median | 325.19 |
| Q3 | 803.86 |
| 95-th percentile | 1431.23 |
| Maximum | 2760.7 |
| Range | 2760.7 |
| Interquartile range (IQR) | 622.3 |
Descriptive statistics
| Standard deviation | 449.18811 |
|---|---|
| Coefficient of variation (CV) | 0.87271615 |
| Kurtosis | 0.012496642 |
| Mean | 514.70126 |
| Median Absolute Deviation (MAD) | 217.35 |
| Skewness | 1.0054596 |
| Sum | 33600213 |
| Variance | 201769.95 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 298 | 1508 | 2.3% |
| 1431.23 | 1426 | 2.2% |
| 966.44 | 1192 | 1.8% |
| 1275.1 | 1126 | 1.7% |
| 192.34 | 1041 | 1.6% |
| 1627.84 | 1035 | 1.6% |
| 157.76 | 988 | 1.5% |
| 1084.61 | 975 | 1.5% |
| 181.44 | 893 | 1.4% |
| 412.03 | 892 | 1.4% |
| Other values (1052) | 54205 |
| Value | Count | Frequency (%) |
| 0 | 295 | |
| 0.3929 | 150 | |
| 0.4 | 21 | < 0.1% |
| 0.405 | 25 | < 0.1% |
| 0.41 | 10 | < 0.1% |
| 0.445 | 6 | < 0.1% |
| 0.52 | 1 | < 0.1% |
| 0.61 | 4 | < 0.1% |
| 1.6236 | 2 | < 0.1% |
| 1.8711 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 2760.7 | 12 | < 0.1% |
| 2291.4 | 7 | < 0.1% |
| 2267 | 10 | < 0.1% |
| 1975 | 113 | |
| 1920 | 61 | |
| 1880 | 19 | < 0.1% |
| 1759.4 | 45 | 0.1% |
| 1731.4 | 35 | 0.1% |
| 1691.4 | 12 | < 0.1% |
| 1688.13 | 150 |
Sales Amount
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 17895 |
|---|---|
| Distinct (%) | 27.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2852.0055 |
| Minimum | 200.01 |
|---|---|
| Maximum | 555376 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | 200.01 |
|---|---|
| 5-th percentile | 215.78 |
| Q1 | 308.38 |
| median | 553.94 |
| Q3 | 1279.96 |
| 95-th percentile | 8777.79 |
| Maximum | 555376 |
| Range | 555175.99 |
| Interquartile range (IQR) | 971.58 |
Descriptive statistics
| Standard deviation | 15164.456 |
|---|---|
| Coefficient of variation (CV) | 5.3171202 |
| Kurtosis | 478.90724 |
| Mean | 2852.0055 |
| Median Absolute Deviation (MAD) | 292.92 |
| Skewness | 18.578552 |
| Sum | 1.8618177 × 108 |
| Variance | 2.2996072 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 784.97 | 115 | 0.2% |
| 817.68 | 115 | 0.2% |
| 294.72 | 110 | 0.2% |
| 307 | 104 | 0.2% |
| 597.14 | 102 | 0.2% |
| 622.02 | 101 | 0.2% |
| 824.39 | 100 | 0.2% |
| 791.41 | 99 | 0.2% |
| 401.16 | 95 | 0.1% |
| 204.66 | 92 | 0.1% |
| Other values (17885) | 64248 |
| Value | Count | Frequency (%) |
| 200.01 | 6 | |
| 200.06 | 6 | |
| 200.08 | 1 | < 0.1% |
| 200.14 | 3 | |
| 200.15 | 5 | |
| 200.19 | 7 | |
| 200.21 | 1 | < 0.1% |
| 200.3 | 3 | |
| 200.36 | 1 | < 0.1% |
| 200.37 | 6 |
| Value | Count | Frequency (%) |
| 555376 | 1 | < 0.1% |
| 539200 | 5 | |
| 517632 | 5 | |
| 472069.6 | 2 | < 0.1% |
| 458320 | 5 | |
| 439987.2 | 5 | |
| 310156.07 | 1 | < 0.1% |
| 301122.4 | 2 | < 0.1% |
| 297240 | 1 | < 0.1% |
| 289077.5 | 2 | < 0.1% |
Sales Amount Based on List Price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 4060 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4707.5457 |
| Minimum | 0 |
|---|---|
| Maximum | 632610.16 |
| Zeros | 295 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 390 |
| Q1 | 561.04 |
| median | 998.16 |
| Q3 | 2315.04 |
| 95-th percentile | 16425.12 |
| Maximum | 632610.16 |
| Range | 632610.16 |
| Interquartile range (IQR) | 1754 |
Descriptive statistics
| Standard deviation | 20696.594 |
|---|---|
| Coefficient of variation (CV) | 4.3964722 |
| Kurtosis | 278.71143 |
| Mean | 4707.5457 |
| Median Absolute Deviation (MAD) | 524.88 |
| Skewness | 14.074724 |
| Sum | 3.0731329 × 108 |
| Variance | 4.2834901 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1431.23 | 590 | 0.9% |
| 1627.84 | 530 | 0.8% |
| 803.86 | 498 | 0.8% |
| 596 | 448 | 0.7% |
| 1254.1899 | 418 | 0.6% |
| 966.44 | 376 | 0.6% |
| 439.7 | 372 | 0.6% |
| 507.75 | 363 | 0.6% |
| 767.75 | 348 | 0.5% |
| 939.57 | 343 | 0.5% |
| Other values (4050) | 60995 |
| Value | Count | Frequency (%) |
| 0 | 295 | |
| 194 | 2 | < 0.1% |
| 195.61 | 1 | < 0.1% |
| 198.396 | 1 | < 0.1% |
| 198.63 | 1 | < 0.1% |
| 200.7 | 8 | < 0.1% |
| 200.8 | 1 | < 0.1% |
| 201.69 | 3 | < 0.1% |
| 202.14 | 1 | < 0.1% |
| 202.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 632610.16 | 5 | |
| 624453.75 | 2 | < 0.1% |
| 539200 | 11 | |
| 458320 | 12 | |
| 391924.7232 | 5 | |
| 387395 | 8 | |
| 348655.5 | 2 | < 0.1% |
| 332196.405 | 2 | < 0.1% |
| 330708.3792 | 5 | |
| 310273.7392 | 2 | < 0.1% |
Sales Cost Amount
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 5513 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1661.0047 |
| Minimum | 0 |
|---|---|
| Maximum | 366576 |
| Zeros | 348 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 85.36 |
| Q1 | 167.79 |
| median | 304.5 |
| Q3 | 687.4 |
| 95-th percentile | 4946.11 |
| Maximum | 366576 |
| Range | 366576 |
| Interquartile range (IQR) | 519.61 |
Descriptive statistics
| Standard deviation | 9556.5562 |
|---|---|
| Coefficient of variation (CV) | 5.7534794 |
| Kurtosis | 614.26709 |
| Mean | 1661.0047 |
| Median Absolute Deviation (MAD) | 171.25 |
| Skewness | 21.010786 |
| Sum | 1.0843205 × 108 |
| Variance | 91327767 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 449.69 | 534 | 0.8% |
| 475.75 | 457 | 0.7% |
| 0 | 348 | 0.5% |
| 134.67 | 305 | 0.5% |
| 162.89 | 289 | 0.4% |
| 205.72 | 253 | 0.4% |
| 159.14 | 242 | 0.4% |
| 16718.08 | 234 | 0.4% |
| 546.44 | 231 | 0.4% |
| 344.28 | 229 | 0.4% |
| Other values (5503) | 62159 |
| Value | Count | Frequency (%) |
| 0 | 348 | |
| 12.97 | 2 | < 0.1% |
| 19.55 | 4 | < 0.1% |
| 20.8 | 6 | < 0.1% |
| 26 | 1 | < 0.1% |
| 31.19 | 4 | < 0.1% |
| 33.97 | 3 | < 0.1% |
| 35.48 | 2 | < 0.1% |
| 35.54 | 5 | < 0.1% |
| 36.03 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 366576 | 7 | < 0.1% |
| 353292.8 | 4 | < 0.1% |
| 311589.6 | 12 | < 0.1% |
| 185048.85 | 2 | < 0.1% |
| 161446.35 | 5 | < 0.1% |
| 157412.85 | 2 | < 0.1% |
| 153635.03 | 5 | < 0.1% |
| 146630.4 | 4 | < 0.1% |
| 141265.56 | 36 | |
| 137736.24 | 4 | < 0.1% |
Sales Margin Amount
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 21295 |
|---|---|
| Distinct (%) | 32.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1191.0008 |
| Minimum | -3932.93 |
|---|---|
| Maximum | 188800 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 576 |
| Negative (%) | 0.9% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | -3932.93 |
|---|---|
| 5-th percentile | 61.54 |
| Q1 | 129.95 |
| median | 246.49 |
| Q3 | 579.32 |
| 95-th percentile | 3824.43 |
| Maximum | 188800 |
| Range | 192732.93 |
| Interquartile range (IQR) | 449.37 |
Descriptive statistics
| Standard deviation | 5860.8134 |
|---|---|
| Coefficient of variation (CV) | 4.9209148 |
| Kurtosis | 324.93262 |
| Mean | 1191.0008 |
| Median Absolute Deviation (MAD) | 140.28 |
| Skewness | 15.571533 |
| Sum | 77749723 |
| Variance | 34349134 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 374.7 | 93 | 0.1% |
| 5317.17 | 88 | 0.1% |
| 6235.31 | 87 | 0.1% |
| 341.72 | 84 | 0.1% |
| 15.32 | 69 | 0.1% |
| 52.8 | 67 | 0.1% |
| 37.08 | 67 | 0.1% |
| 431.88 | 64 | 0.1% |
| 464.59 | 64 | 0.1% |
| 24.53 | 63 | 0.1% |
| Other values (21285) | 64535 |
| Value | Count | Frequency (%) |
| -3932.93 | 1 | |
| -3764.4 | 2 | |
| -3673.68 | 2 | |
| -3608.81 | 1 | |
| -3414.01 | 2 | |
| -3132.65 | 2 | |
| -2533.97 | 2 | |
| -2508.21 | 2 | |
| -2488.89 | 1 | |
| -2103.04 | 2 |
| Value | Count | Frequency (%) |
| 188800 | 1 | < 0.1% |
| 185907.2 | 2 | |
| 172624 | 3 | |
| 164339.2 | 2 | |
| 160480 | 2 | |
| 156773.4 | 1 | < 0.1% |
| 156521.04 | 1 | < 0.1% |
| 151056 | 3 | |
| 148401.6 | 3 | |
| 147487.37 | 2 |
Sales Price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 14789 |
|---|---|
| Distinct (%) | 22.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 283.69685 |
| Minimum | 0.33734118 |
|---|---|
| Maximum | 6035 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | 0.33734118 |
|---|---|
| 5-th percentile | 22.425556 |
| Q1 | 100.07 |
| median | 183.759 |
| Q3 | 448.22 |
| 95-th percentile | 789.66 |
| Maximum | 6035 |
| Range | 6034.6627 |
| Interquartile range (IQR) | 348.15 |
Descriptive statistics
| Standard deviation | 252.02973 |
|---|---|
| Coefficient of variation (CV) | 0.88837691 |
| Kurtosis | 6.8826841 |
| Mean | 283.69685 |
| Median Absolute Deviation (MAD) | 116.471 |
| Skewness | 1.4189862 |
| Sum | 18520014 |
| Variance | 63518.984 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 140.43 | 191 | 0.3% |
| 817.68 | 189 | 0.3% |
| 133.41 | 181 | 0.3% |
| 824.39 | 138 | 0.2% |
| 783.17 | 138 | 0.2% |
| 23.47 | 136 | 0.2% |
| 82.87333333 | 125 | 0.2% |
| 230.98 | 120 | 0.2% |
| 221.04 | 120 | 0.2% |
| 230.25 | 120 | 0.2% |
| Other values (14779) | 63823 |
| Value | Count | Frequency (%) |
| 0.3373411765 | 2 | < 0.1% |
| 0.3514 | 1 | < 0.1% |
| 0.3619411765 | 1 | < 0.1% |
| 0.37718 | 67 | |
| 0.384 | 9 | < 0.1% |
| 0.3888 | 12 | < 0.1% |
| 0.3929 | 67 | |
| 0.3936 | 5 | < 0.1% |
| 0.4 | 9 | < 0.1% |
| 0.40469 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 6035 | 1 | |
| 3748 | 2 | |
| 3233.36 | 1 | |
| 3009.86 | 1 | |
| 3003.41 | 1 | |
| 2823 | 1 | |
| 2753.32 | 1 | |
| 2560 | 1 | |
| 2540.17 | 1 | |
| 2360.1 | 1 |
Sales Quantity
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 280 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.085017 |
| Minimum | 0 |
|---|---|
| Maximum | 16000 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 510.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 8 |
| 95-th percentile | 86 |
| Maximum | 16000 |
| Range | 16000 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 429.66505 |
|---|---|
| Coefficient of variation (CV) | 9.5301072 |
| Kurtosis | 649.74753 |
| Mean | 45.085017 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 23.007396 |
| Sum | 2943195 |
| Variance | 184612.05 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 15264 | |
| 2 | 13466 | |
| 3 | 7056 | |
| 4 | 4973 | 7.6% |
| 5 | 3519 | 5.4% |
| 6 | 3061 | 4.7% |
| 10 | 2596 | 4.0% |
| 8 | 1460 | 2.2% |
| 12 | 1314 | 2.0% |
| 20 | 1034 | 1.6% |
| Other values (270) | 11538 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 15264 | |
| 2 | 13466 | |
| 3 | 7056 | |
| 4 | 4973 | 7.6% |
| 5 | 3519 | 5.4% |
| 6 | 3061 | 4.7% |
| 7 | 711 | 1.1% |
| 8 | 1460 | 2.2% |
| 9 | 453 | 0.7% |
| Value | Count | Frequency (%) |
| 16000 | 11 | < 0.1% |
| 13600 | 12 | < 0.1% |
| 9504 | 7 | < 0.1% |
| 8316 | 40 | |
| 7128 | 21 | |
| 7126 | 2 | < 0.1% |
| 6480 | 2 | < 0.1% |
| 6400 | 4 | < 0.1% |
| 5834 | 4 | < 0.1% |
| 4752 | 13 | < 0.1% |
Year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 510.1 KiB |
| 2017 | |
|---|---|
| 2019 | |
| 2018 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 261124 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017 |
|---|---|
| 2nd row | 2017 |
| 3rd row | 2017 |
| 4th row | 2017 |
| 5th row | 2017 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 30574 | |
| 2019 | 28021 | |
| 2018 | 6686 | 10.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2017 | 30574 | |
| 2019 | 28021 | |
| 2018 | 6686 | 10.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 65281 | |
| 0 | 65281 | |
| 1 | 65281 | |
| 7 | 30574 | |
| 9 | 28021 | |
| 8 | 6686 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 261124 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 65281 | |
| 0 | 65281 | |
| 1 | 65281 | |
| 7 | 30574 | |
| 9 | 28021 | |
| 8 | 6686 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 261124 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 65281 | |
| 0 | 65281 | |
| 1 | 65281 | |
| 7 | 30574 | |
| 9 | 28021 | |
| 8 | 6686 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 261124 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 65281 | |
| 0 | 65281 | |
| 1 | 65281 | |
| 7 | 30574 | |
| 9 | 28021 | |
| 8 | 6686 | 2.6% |
Month
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 510.1 KiB |
| Mar | |
|---|---|
| Feb | |
| Jan | |
| Dec | |
| Sep | |
| Other values (7) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 195843 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jan |
|---|---|
| 2nd row | Jan |
| 3rd row | Jan |
| 4th row | Jan |
| 5th row | Jan |
Common Values
| Value | Count | Frequency (%) |
| Mar | 7308 | |
| Feb | 6556 | |
| Jan | 6066 | |
| Dec | 5645 | |
| Sep | 5555 | |
| Jun | 5376 | |
| Oct | 5250 | |
| Nov | 5247 | |
| May | 5167 | |
| Aug | 4738 | |
| Other values (2) | 8373 |
Length
| Value | Count | Frequency (%) |
| mar | 7308 | |
| feb | 6556 | |
| jan | 6066 | |
| dec | 5645 | |
| sep | 5555 | |
| jun | 5376 | |
| oct | 5250 | |
| nov | 5247 | |
| may | 5167 | |
| aug | 4738 | |
| Other values (2) | 8373 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 18541 | 9.5% |
| e | 17756 | 9.1% |
| J | 15838 | 8.1% |
| u | 14510 | 7.4% |
| M | 12475 | 6.4% |
| n | 11442 | 5.8% |
| r | 11285 | 5.8% |
| c | 10895 | 5.6% |
| p | 9532 | 4.9% |
| A | 8715 | 4.4% |
| Other values (12) | 64854 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 130562 | |
| Uppercase Letter | 65281 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 18541 | |
| e | 17756 | |
| u | 14510 | |
| n | 11442 | |
| r | 11285 | |
| c | 10895 | |
| p | 9532 | |
| b | 6556 | 5.0% |
| t | 5250 | 4.0% |
| o | 5247 | 4.0% |
| Other values (4) | 19548 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 15838 | |
| M | 12475 | |
| A | 8715 | |
| F | 6556 | |
| D | 5645 | 8.6% |
| S | 5555 | 8.5% |
| O | 5250 | 8.0% |
| N | 5247 | 8.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 195843 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 18541 | 9.5% |
| e | 17756 | 9.1% |
| J | 15838 | 8.1% |
| u | 14510 | 7.4% |
| M | 12475 | 6.4% |
| n | 11442 | 5.8% |
| r | 11285 | 5.8% |
| c | 10895 | 5.6% |
| p | 9532 | 4.9% |
| A | 8715 | 4.4% |
| Other values (12) | 64854 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 195843 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 18541 | 9.5% |
| e | 17756 | 9.1% |
| J | 15838 | 8.1% |
| u | 14510 | 7.4% |
| M | 12475 | 6.4% |
| n | 11442 | 5.8% |
| r | 11285 | 5.8% |
| c | 10895 | 5.6% |
| p | 9532 | 4.9% |
| A | 8715 | 4.4% |
| Other values (12) | 64854 |
| CustKey | Discount Amount | List Price | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CustKey | 1.000 | -0.016 | -0.008 | 0.015 | 0.006 | 0.019 | 0.011 | -0.004 | 0.011 | 0.171 | 0.048 |
| Discount Amount | -0.016 | 1.000 | 0.438 | 0.823 | 0.896 | 0.783 | 0.731 | 0.367 | 0.380 | 0.000 | 0.015 |
| List Price | -0.008 | 0.438 | 1.000 | 0.356 | 0.383 | 0.389 | 0.285 | 0.977 | -0.542 | 0.005 | 0.023 |
| Sales Amount | 0.015 | 0.823 | 0.356 | 1.000 | 0.967 | 0.930 | 0.890 | 0.358 | 0.484 | 0.011 | 0.006 |
| Sales Amount Based on List Price | 0.006 | 0.896 | 0.383 | 0.967 | 1.000 | 0.913 | 0.859 | 0.346 | 0.476 | 0.000 | 0.008 |
| Sales Cost Amount | 0.019 | 0.783 | 0.389 | 0.930 | 0.913 | 1.000 | 0.706 | 0.373 | 0.423 | 0.000 | 0.005 |
| Sales Margin Amount | 0.011 | 0.731 | 0.285 | 0.890 | 0.859 | 0.706 | 1.000 | 0.300 | 0.474 | 0.012 | 0.005 |
| Sales Price | -0.004 | 0.367 | 0.977 | 0.358 | 0.346 | 0.373 | 0.300 | 1.000 | -0.567 | 0.024 | 0.011 |
| Sales Quantity | 0.011 | 0.380 | -0.542 | 0.484 | 0.476 | 0.423 | 0.474 | -0.567 | 1.000 | 0.000 | 0.004 |
| Year | 0.171 | 0.000 | 0.005 | 0.011 | 0.000 | 0.000 | 0.012 | 0.024 | 0.000 | 1.000 | 0.370 |
| Month | 0.048 | 0.015 | 0.023 | 0.006 | 0.008 | 0.005 | 0.005 | 0.011 | 0.004 | 0.370 | 1.000 |
| CustKey | Discount Amount | Item | List Price | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10000460 | 158.04 | Nationeel Salted Pretzels | 181.44 | 204.84 | 362.88 | 59.73 | 145.11 | 102.420000 | 2 | 2017 | Jan |
| 1 | 10000460 | 420.90 | Ebony Prepared Salad | 966.44 | 545.54 | 966.44 | 278.38 | 267.16 | 545.540000 | 1 | 2017 | Jan |
| 2 | 10000460 | 663.41 | Thresher Spicy Mints | 507.75 | 859.84 | 1523.25 | 488.68 | 371.16 | 286.613333 | 3 | 2017 | Jan |
| 3 | 10000460 | 179.45 | Big Time Frozen Cheese Pizza | 412.03 | 232.58 | 412.03 | 84.23 | 148.35 | 232.580000 | 1 | 2017 | Jan |
| 4 | 10000460 | 1516.52 | Red Spade Turkey Hot Dogs | 1160.70 | 1965.58 | 3482.10 | 957.15 | 1008.43 | 655.193333 | 3 | 2017 | Jan |
| 5 | 10000460 | 274.83 | Ebony Canned Peanuts | 157.76 | 356.21 | 631.04 | 237.28 | 118.93 | 89.052500 | 4 | 2017 | Jan |
| 6 | 10004302 | 495.15 | Even Better Low Fat String Cheese | 561.04 | 626.93 | 1122.08 | 395.98 | 230.95 | 313.465000 | 2 | 2017 | Jan |
| 7 | 10006862 | 232.25 | Even Better String Cheese | 263.15 | 294.05 | 526.30 | 203.05 | 91.00 | 147.025000 | 2 | 2017 | Jan |
| 8 | 10006862 | 247.58 | Even Better Low Fat String Cheese | 561.04 | 313.46 | 561.04 | 197.99 | 115.47 | 313.460000 | 1 | 2017 | Jan |
| 9 | 10006862 | 330.09 | Washington Cranberry Juice | 187.01 | 417.95 | 748.04 | 211.87 | 206.08 | 104.487500 | 4 | 2017 | Jan |
| CustKey | Discount Amount | Item | List Price | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65271 | 10023511 | 489.0600 | BBB Best Apple Butter | 515.1400 | 541.22 | 1030.2800 | 307.80 | 233.42 | 270.610000 | 2 | 2019 | Dec |
| 65272 | 10023511 | 684.2800 | Walrus Light Beer | 288.3100 | 757.27 | 1441.5500 | 465.89 | 291.38 | 151.454000 | 5 | 2019 | Dec |
| 65273 | 10023793 | 917.5200 | Ebony Prepared Salad | 966.4400 | 1015.36 | 1932.8800 | 544.55 | 470.81 | 507.680000 | 2 | 2019 | Dec |
| 65274 | 10023793 | 2662.4500 | Moms Sliced Ham | 101.0000 | 2387.55 | 5050.0000 | 1467.83 | 919.72 | 47.751000 | 50 | 2019 | Dec |
| 65275 | 10026081 | 397.8448 | Better Rice Soup | 38.5506 | 9548.21 | 9946.0548 | 4826.77 | 4721.44 | 37.008566 | 258 | 2019 | Dec |
| 65276 | 10026081 | 272.5230 | Better Fancy Canned Sardines | 39.1545 | 6540.36 | 6812.8830 | 2969.78 | 3570.58 | 37.588276 | 174 | 2019 | Dec |
| 65277 | 10026081 | 548.2520 | Monarch Spaghetti | 40.3128 | 13158.10 | 13706.3520 | 6424.27 | 6733.83 | 38.700294 | 340 | 2019 | Dec |
| 65278 | 10026081 | 26.2588 | Moms Cole Slaw | 27.3537 | 630.23 | 656.4888 | 421.22 | 209.01 | 26.259583 | 24 | 2019 | Dec |
| 65279 | 10026081 | 447.6400 | Swell Canned Peaches | 14.2560 | 10743.32 | 11190.9600 | 6258.02 | 4485.30 | 13.685758 | 785 | 2019 | Dec |
| 65280 | 10026606 | 15.7200 | Walrus Chardonnay | 0.3929 | 377.18 | 392.9000 | 340.10 | 37.08 | 0.377180 | 1000 | 2019 | Dec |
Most frequently occurring
| CustKey | Discount Amount | Item | List Price | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Year | Month | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3093 | 10025552 | 601.9033 | Washington Apple Drink | 1419.5833 | 817.68 | 1419.5833 | 353.09 | 464.59 | 817.68 | 1 | 2017 | Oct | 21 |
| 850 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 353.09 | 431.88 | 784.97 | 1 | 2019 | Dec | 20 |
| 852 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 353.09 | 431.88 | 784.97 | 1 | 2019 | Oct | 20 |
| 3090 | 10025552 | 601.9033 | Washington Apple Drink | 1419.5833 | 817.68 | 1419.5833 | 353.09 | 464.59 | 817.68 | 1 | 2017 | Dec | 20 |
| 422 | 10008638 | 24.8800 | High Top Walnuts | 622.0200 | 597.14 | 622.0200 | 286.38 | 310.76 | 597.14 | 1 | 2019 | Jun | 16 |
| 851 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 353.09 | 431.88 | 784.97 | 1 | 2019 | Nov | 16 |
| 2389 | 10021986 | 0.0000 | High Top Walnuts | 622.0200 | 622.02 | 622.0200 | 286.38 | 335.64 | 622.02 | 1 | 2017 | Jun | 15 |
| 425 | 10008638 | 24.8800 | High Top Walnuts | 622.0200 | 597.14 | 622.0200 | 287.65 | 309.49 | 597.14 | 1 | 2019 | Dec | 14 |
| 853 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 359.20 | 425.77 | 784.97 | 1 | 2019 | Mar | 14 |
| 854 | 10013080 | 634.6133 | Washington Apple Drink | 1419.5833 | 784.97 | 1419.5833 | 359.20 | 425.77 | 784.97 | 1 | 2019 | Sep | 14 |